package com.tupu.mapper.dispatch;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tupu.entity.dispatch.StandardizationNameStandard;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface StandardizationNameStandardMapper extends BaseMapper<StandardizationNameStandard> {

    @Select("SELECT match_word as matchWord, GROUP_CONCAT(enum_name SEPARATOR '、') as enumNames, GROUP_CONCAT(standard_id SEPARATOR '_') as ids FROM tb_standardization_namestandard GROUP BY match_word")
    List<Map<String, Object>> listGroupByMatchWord();
}
